Christian G. ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	12

About Me

About Me

Area of Expertise	Automation
About Me	Smartsheet Self taught
How I Use Smartsheet	Everyday, for everything

Analytics

111

Posts

165

Visits

1.3k

Points

Sep 14, 2022

Join Date

Oct 26, 2023

Last Active

Reactions

• Insightful 2

  2
• Vote Up 23

  23
• Awesome 12

  12

• Activity
• Discussions5
• Comments106

• Re: Calculating Avg Workdays w/ Conditions

  Christian G.

  06/29/23
  Your "if" statement is not correctly stated. Use a Collect to agglomerate data that you want to calculate. =AVG(Collect([what you want to average], Critera range1, Critera1, criteria range …
  1 ·

• Re: Can I copy gantt lines from one sheet to another and retain structure?

  Christian G.

  10/17/22
  One solution would be to match the lines in the file you want to copy to where they will be when pasted. For example, if row 1 of the original is to be pasted onto row 6, add 5 blank rows above row 1…
  1 ·